Implementing Data Warehouses on AWS
Back to Home
01. Lesson Introduction
02. Data Warehouse: A Closer Look
03. Choices for Implementing a Data Warehouse
04. DWH Dimensional Model Storage on AWS
05. Amazon Redshift Technology
06. Amazon Redshift Architecture
07. Redshift Architecture Example
08. SQL to SQL ETL
09. SQL to SQL ETL - AWS Case
10. Redshift & ETL in Context
11. Ingesting at Scale
12. Redshift ETL Examples
13. Redshift ETL Continued
14. Redshift Cluster Quick Launcher
15. Exercise 1: Launch Redshift Cluster
16. Problems with the Quick Launcher
17. Infrastructure as Code on AWS
18. Enabling Programmatic Access fo IaC
19. Demo: Infrastructure as Code
20. Exercise 2: Infrastructure as Code
21. Exercise Solution 2: Infrastructure as Code
22. Demo: Parallel ETL
23. Exercise 3: Parallel ETL
24. Exercise Solution 3: Parallel ETL
25. Optimizing Table Design
26. Distribution Style: Even
27. Distribution Style: All
28. Distribution Syle: Auto
29. Distribution Syle: Key
30. Sorting Key
31. Sorting Key Example
32. Demo: Table Design
33. Exercise 4: Table Design
34. Exercise Solution 4: Table Design
35. Conclusion
Back to Home
25. Optimizing Table Design
L03-08-OptimizingDesign-Part1 Optimizing Table Design
Next Concept